
UPDATE FLW_ID_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

CREATE TABLE FLW_ID_DESIGN_AUTHENTICATION (ID_ VARCHAR2(255) NOT NULL, USER_ID_ VARCHAR2(100), TENANT_ID_ VARCHAR2(255), CREATE_TIME_ TIMESTAMP(6) NOT NULL, TOKEN_ VARCHAR2(2000), CONSTRAINT PK_FLW_ID_DESIGN_AUTHENTICATIO PRIMARY KEY (ID_));

INSERT INTO FLW_ID_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('18', 'flowable', 'com/flowable/platform/idm/db/liquibase/flowable-idm-db-changelog.xml', SYSTIMESTAMP, 18, '8:e547bed8a41fa82c9169f047a8a53000', 'createTable tableName=FLW_ID_DESIGN_AUTHENTICATION; addUniqueConstraint constraintName=FLW_UQ_ID_DE_AUTH_USER_TENANT, tableName=FLW_ID_DESIGN_AUTHENTICATION', '', 'EXECUTED', NULL, NULL, '4.11.0', '9860581583');

UPDATE FLW_ID_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_LIC_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_PL_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

CREATE TABLE FLW_DATA_DICTIONARY_DEFINITION (ID_ VARCHAR2(255) NOT NULL, REV_ INTEGER NOT NULL, KEY_ VARCHAR2(128), VERSION_ INTEGER, DEPLOYMENT_ID_ VARCHAR2(255) NOT NULL, NAME_ VARCHAR2(128), RESOURCE_NAME_ VARCHAR2(4000), TENANT_ID_ VARCHAR2(64) DEFAULT '', CONSTRAINT PK_FLW_DATA_DICTIONARY_DEF PRIMARY KEY (ID_));

CREATE UNIQUE INDEX IDX_FLW_DATA_DICT_DEF_UNIQ ON FLW_DATA_DICTIONARY_DEFINITION(KEY_, VERSION_, TENANT_ID_);

CREATE INDEX IDX_DATA_DICT_DEF_DEPLOYMENT ON FLW_DATA_DICTIONARY_DEFINITION(DEPLOYMENT_ID_);

ALTER TABLE FLW_DATA_DICTIONARY_DEFINITION ADD CONSTRAINT FK_DATA_DICT_DEF_DEPLOYMENT FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES FLW_PL_DEPLOYMENT (ID_);

INSERT INTO FLW_PL_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('9', 'flowable', 'com/flowable/platform/db/liquibase/flowable-platform-db-changelog.xml', SYSTIMESTAMP, 9, '8:ee732251f224e74f32c403cab579e438', 'createTable tableName=FLW_DATA_DICTIONARY_DEFINITION; createIndex indexName=IDX_FLW_DATA_DICT_DEF_UNIQ, tableName=FLW_DATA_DICTIONARY_DEFINITION; createIndex indexName=IDX_DATA_DICT_DEF_DEPLOYMENT, tableName=FLW_DATA_DICTIONARY_DEFINITION; addFore...', '', 'EXECUTED', NULL, NULL, '4.11.0', '9860586397');

UPDATE FLW_PL_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE ACT_APP_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

CREATE TABLE ACT_APP_VARIABLE (ID_ VARCHAR2(255) NOT NULL, REV_ INTEGER NOT NULL, TYPE_ VARCHAR2(255), NAME_ VARCHAR2(255) NOT NULL, APP_KEY_ VARCHAR2(255) NOT NULL, TENANT_ID_ VARCHAR2(255), BYTEARRAY_ID_ VARCHAR2(64), DOUBLE_ FLOAT(24), LONG_ NUMBER(38, 0), TEXT_ VARCHAR2(4000), CONSTRAINT PK_ACT_APP_VARIABLE PRIMARY KEY (ID_));

CREATE INDEX ACT_IDX_APP_VAR_KEY ON ACT_APP_VARIABLE(APP_KEY_);

CREATE INDEX ACT_IDX_APP_VAR_KEY_TENANT ON ACT_APP_VARIABLE(APP_KEY_, TENANT_ID_);

INSERT INTO ACT_APP_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('6', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', SYSTIMESTAMP, 5, '8:aeccd1562546a9b163921135ec5702c1', 'createTable tableName=ACT_APP_VARIABLE; createIndex indexName=ACT_IDX_APP_VAR_KEY, tableName=ACT_APP_VARIABLE; createIndex indexName=ACT_IDX_APP_VAR_KEY_TENANT, tableName=ACT_APP_VARIABLE', '', 'EXECUTED', NULL, NULL, '4.11.0', '9860588806');

CREATE TABLE ACT_APP_INCIDENT (ID_ VARCHAR2(255) NOT NULL, TYPE_ VARCHAR2(255) NOT NULL, SUB_TYPE_ VARCHAR2(255), APP_KEY_ VARCHAR2(255), SCOPE_DEFINITION_ID_ VARCHAR2(255), SCOPE_ID_ VARCHAR2(255), SUB_SCOPE_ID_ VARCHAR2(255), SCOPE_TYPE_ VARCHAR2(255), TENANT_ID_ VARCHAR2(255), INCIDENT_INFO_ CLOB, CREATE_TIME_ TIMESTAMP(6) NOT NULL, CONSTRAINT PK_ACT_APP_INCIDENT PRIMARY KEY (ID_));

CREATE INDEX ACT_IDX_APP_INC_KEY ON ACT_APP_INCIDENT(APP_KEY_);

CREATE INDEX ACT_IDX_APP_INC_KEY_TENANT ON ACT_APP_INCIDENT(APP_KEY_, TENANT_ID_);

CREATE INDEX ACT_IDX_APP_INC_SCOPE ON ACT_APP_INCIDENT(SCOPE_ID_, SCOPE_TYPE_);

INSERT INTO ACT_APP_DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('7', 'flowable', 'org/flowable/app/db/liquibase/flowable-app-db-changelog.xml', SYSTIMESTAMP, 6, '8:75ade721311b03940adab8bb5732b459', 'createTable tableName=ACT_APP_INCIDENT; createIndex indexName=ACT_IDX_APP_INC_KEY, tableName=ACT_APP_INCIDENT; createIndex indexName=ACT_IDX_APP_INC_KEY_TENANT, tableName=ACT_APP_INCIDENT; createIndex indexName=ACT_IDX_APP_INC_SCOPE, tableName=ACT...', '', 'EXECUTED', NULL, NULL, '4.11.0', '9860588806');

UPDATE ACT_APP_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_FO_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_FO_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_CO_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_CO_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_AD_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_AD_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_AU_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_AU_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_DO_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_DO_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_PO_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_PO_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_SE_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_SE_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;


UPDATE FLW_TP_DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.68.121 (192.168.68.121)', LOCKGRANTED = SYSTIMESTAMP WHERE ID = 1 AND LOCKED = 0;

UPDATE FLW_TP_DATABASECHANGELOGLOCK SET LOCKED = 0, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1;

